{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":196,"n_cols":11,"rows_kept":196,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,6,0,9],[1,6,1,9],[23,1,23,2],[42,1,42,2],[61,1,61,2],[80,1,80,2],[99,1,99,2],[118,1,118,2],[137,1,137,2],[156,1,156,2],[175,1,175,2],[194,1,194,2],[195,1,195,3]]}
[null,"МАОУ \"Троельжанская СОШ\"",null,null,"Утвердил:","должность","директор"]
[{"$nulls":5},"фамилия","Мясникова Т.А."]
[null,null,null,"12-17 лет",null,"дата",1,4,2025]
[{"$nulls":6},"день","месяц","год"]
["День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E6:E12)","v":0},0,0,0,0,null,{"$f":"SUM(K6:K12)","v":0}]
[{"$f":"A6","v":1},"Обед","закуска"]
[null,null,"1 блюдо","Суп гороховый ",250,2.3,4.25,15.13,108,144,20.64]
[null,null,"2 блюдо","Биточки из кур с соусом ",100,12.13,12.6,9.91,202,"412/435",61.74]
[null,null,"гарнир","Макаронные изделия отв.",180,6.03,0.72,30.98,155,291,19.37]
[null,null,"напиток","Напиток из шиповника ",200,0.7,0.3,22.8,97,519,9.71]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0.48,30,141,108,3.72]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0.36,10,52,109,3]
[{"$nulls":4},820,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E14:E22)","v":1640},28.16,18.71,118.82,755,null,{"$f":"SUM(K14:K22)","v":236.36}]
[{"$f":"A6","v":1},"Итого за день:",null,null,{"$f":"E13+E23","v":1640},28.16,18.71,118.82,755,null,{"$f":"K13+K23","v":236.36}]
[2,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E25:E31)","v":0},0,0,0,0,null,{"$f":"SUM(K25:K31)","v":0}]
[{"$f":"A25","v":2},"Обед","закуска"]
[null,null,"1 блюдо","Суп-пюре с гренками ",260,2.55,5.58,13.9,209,"159/170",34.08]
[null,null,"2 блюдо","Тефтели из говядины в мол.соусе ",100,10.36,12.27,8.14,170,388,54.07]
[null,null,"гарнир","Рис отварной ",180,10.26,9.41,44.5,205,414,19.03]
[null,null,"напиток","Чай с сахаром ",200,3.2,2.7,15.9,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,3]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},830,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E33:E41)","v":1660},33.37,29.96,122.44,837,null,{"$f":"SUM(K33:K41)","v":236.36}]
[{"$f":"A25","v":2},"Итого за день:",null,null,{"$f":"E32+E42","v":1660},33.37,29.96,122.44,837,null,{"$f":"K32+K42","v":236.36}]
[3,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E44:E50)","v":0},0,0,0,0,null,{"$f":"SUM(K44:K50)","v":0}]
[{"$f":"A44","v":3},"Обед","закуска"]
[null,null,"1 блюдо","Борщ со сметаной ",255,1.96,5.75,10.83,103,"128/479",19.68]
[null,null,"2 блюдо","Рыба,туш.с овощами ",100,8.87,5.14,4.2,102,343,42.26]
[null,null,"гарнир","Картофельное пюре ",180,3.36,7.04,17.44,147,429,31.74]
[null,null,"напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,15.5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E52:E60)","v":1650},21.69,17.93,99.47,655,null,{"$f":"SUM(K52:K60)","v":236.36}]
[{"$f":"A44","v":3},"Итого за день:",null,null,{"$f":"E51+E61","v":1650},21.69,17.93,99.47,655,null,{"$f":"K51+K61","v":236.36}]
[4,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E63:E69)","v":0},0,0,0,0,null,{"$f":"SUM(K63:K69)","v":0}]
[{"$f":"A63","v":4},"Обед","закуска"]
[null,null,"1 блюдо","Рассольник со сметаной",255,2.18,6,16.43,129,"134/479",22.08]
[null,null,"2 блюдо","Фрикадельки из кур с соусом ",100,8.86,9.68,8.23,156,"410/435",53.02]
[null,null,"гарнир","Каша пшенная ",180,6.98,10.29,29.7,239,258,22.4]
[null,null,"напиток","Компот из свежих фруктов ",200,0.5,0.2,23.1,96,507,12.59]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,4.56,0,30,141,108,5.09]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E71:E79)","v":1650},25.08,26.17,117.46,813,null,{"$f":"SUM(K71:K79)","v":236.36}]
[{"$f":"A63","v":4},"Итого за день:",null,null,{"$f":"E70+E80","v":1650},25.08,26.17,117.46,813,null,{"$f":"K70+K80","v":236.36}]
[5,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E82:E88)","v":0},0,0,0,0,null,{"$f":"SUM(K82:K88)","v":0}]
[{"$f":"A82","v":5},"Обед","закуска"]
[null,null,"1 блюдо","Суп гороховый ",250,2.3,4.25,15.13,108,144,20.64]
[null,null,"2 блюдо","Кнели из говядины с соусом ",100,9.92,9.98,7.23,162,"379/435",61.94]
[null,null,"гарнир","Каша ячневая ",180,5.12,9.12,28.61,217,255,21.6]
[null,null,"напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},820,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E90:E98)","v":1640},24.44,23.35,105.97,740,null,{"$f":"SUM(K90:K98)","v":236.36}]
[{"$f":"A82","v":5},"Итого за день:",null,null,{"$f":"E89+E99","v":1640},24.44,23.35,105.97,740,null,{"$f":"K89+K99","v":236.36}]
[1,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E101:E107)","v":0},0,0,0,0,null,{"$f":"SUM(K101:K107)","v":0}]
[{"$f":"A101","v":1},"Обед","закуска"]
[null,null,"1 блюдо","Суп крестьянский со сметаной ",255,2.26,5.85,14.73,121,"154/479",15.85]
[null,null,"2 блюдо","Биточки из гов.с соусом ",100,10.62,12.23,11.58,199,"381/435",61.37]
[null,null,"гарнир","Макаронные изделия отварные ",180,6.03,0.72,30.98,155,291,19.37]
[null,null,"напиток","Компои из свежих фруктов ",200,0.5,0.2,23.1,96,507,12.59]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E109:E117)","v":1650},26.41,19,120.39,764,null,{"$f":"SUM(K109:K117)","v":236.36}]
[{"$f":"A101","v":1},"Итого за день:",null,null,{"$f":"E108+E118","v":1650},26.41,19,120.39,764,null,{"$f":"K108+K118","v":236.36}]
[2,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E120:E126)","v":0},0,0,0,0,null,{"$f":"SUM(K120:K126)","v":0}]
[{"$f":"A120","v":2},"Обед","закуска"]
[null,null,"1 блюдо","Рассольник со сметаной",255,2,6,16,129,"134/479",22.08]
[null,null,"2 блюдо","Кнели рыбные с соусом ",100,8.52,4.18,7.18,101,"334/435",50.14]
[null,null,"гарнир","Картофельное пюре ",180,3.36,7.04,17.44,147,429,31.74]
[null,null,"напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,4.56,0.48,29.52,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,1.98,0.36,10.02,52,109,3.22]
[{"$nulls":4},825,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E128:E136)","v":1650},20.42,18.06,95.16,630,null,{"$f":"SUM(K128:K136)","v":236.36}]
[{"$f":"A120","v":2},"Итого за день:",null,null,{"$f":"E127+E137","v":1650},20.42,18.06,95.16,630,null,{"$f":"K127+K137","v":236.36}]
[3,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E139:E145)","v":0},0,0,0,0,null,{"$f":"SUM(K139:K145)","v":0}]
[{"$f":"A139","v":3},"Обед","закуска"]
[null,null,"1 блюдо","Борщ со сметаной ",255,1.96,5.75,10.83,103,"128/479",19.68]
[null,null,"2 блюдо","Фрикадельки из кур с соусом ",100,9,10,8,156,"410/435",53.02]
[null,null,"гарнир","Каша гречневая ",180,9.12,8.37,39.55,270,237,20.98]
[null,null,"напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,15.5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,4.56,0,29.52,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E147:E155)","v":1650},27.14,24.12,124.9,832,null,{"$f":"SUM(K147:K155)","v":236.36}]
[{"$f":"A139","v":3},"Итого за день:",null,null,{"$f":"E146+E156","v":1650},27.14,24.12,124.9,832,null,{"$f":"K146+K156","v":236.36}]
[4,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E158:E164)","v":0},0,0,0,0,null,{"$f":"SUM(K158:K164)","v":0}]
[{"$f":"A158","v":4},"Обед","закуска"]
[null,null,"1 блюдо","Суп гороховый ",250,2,4,15,108,144,20.64]
[null,null,"2 блюдо","Шницели из гов.с соусом ",100,10.62,12.23,11.58,199,"381/435",61.37]
[null,null,"гарнир","Каша ячневая ",180,5.12,9.12,28.61,217,255,21.59]
[null,null,"напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0.48,29.52,141,108,6.58]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0.36,10.02,52,109,3]
[{"$nulls":4},820,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E166:E174)","v":1640},24.84,26.19,109.73,777,null,{"$f":"SUM(K166:K174)","v":236.36}]
[{"$f":"A158","v":4},"Итого за день:",null,null,{"$f":"E165+E175","v":1640},24.84,26.19,109.73,777,null,{"$f":"K165+K175","v":236.36}]
[5,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E177:E183)","v":0},0,0,0,0,null,{"$f":"SUM(K177:K183)","v":0}]
[{"$f":"A177","v":5},"Обед","закуска"]
[null,null,"1 блюдо","Суп-пюре с гренками ",260,5.98,6.56,31.72,209,"159/170",34.08]
[null,null,"2 блюдо","Тефтели из говядины в мол.соусе ",100,10.3,10.7,8,170,388,54.07]
[null,null,"гарнир","Рис отварной ",180,3.69,6.08,33.81,205,414,19.03]
[null,null,"напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,3]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},830,{"$nulls":5},118.18]
[]
[null,null,"итого",null,{"$f":"SUM(E185:E193)","v":1660},27.07,23.34,128.53,837,null,{"$f":"SUM(K185:K193)","v":236.36}]
[{"$f":"A177","v":5},"Итого за день:",null,null,{"$f":"E184+E194","v":1660},27.07,23.34,128.53,837,null,{"$f":"K184+K194","v":236.36}]
[null,"Среднее значение за период:",null,null,{"$f":"(E24+E43+E62+E81+E100+E119+E138+E157+E176+E195)/(IF(E24=0,0,1)+IF(E43=0,0,1)+IF(E62=0,0,1)+IF(E81=0,0,1)+IF(E100=0,0,1)+IF(E119=0,0,1)+IF(E138=0,0,1)+IF(E157=0,0,1)+IF(E176=0,0,1)+IF(E195=0,0,1))","v":1649},25.862,22.683,114.287,764,null,{"$f":"(K24+K43+K62+K81+K100+K119+K138+K157+K176+K195)/(IF(K24=0,0,1)+IF(K43=0,0,1)+IF(K62=0,0,1)+IF(K81=0,0,1)+IF(K100=0,0,1)+IF(K119=0,0,1)+IF(K138=0,0,1)+IF(K157=0,0,1)+IF(K176=0,0,1)+IF(K195=0,0,1))","v":236.36}]